api/maintenance_views.py

@@ -3,8 +3,10 @@

                 from __future__ import division
              

                 
              

                 import json
              

                +from datetime import datetime
              

                 
              

                 from django.conf import settings
              

                +from django.db.models.query_utils import Q
              

                 from django_logit import logit
              

                 from django_response import response
              

                 from paginator import pagination
              
@@ -181,10 +183,25 @@ def maintenance_list(request):

                     user_id = request.POST.get('user_id', '')
              

                     page = request.POST.get('page', 1)
              

                     num = request.POST.get('num', 20)
              

                +    query = request.POST.get('query', '')
              

                +    maintenance_status = request.POST.get('maintenance_status', '')
              

                +    start_time = request.POST.get('start_time', '')
              

                +    end_time = request.POST.get('end_time', '')
              

                 
              

                     maintenances = MaintenaceInfo.objects.filter(status=True)
              

                     if not is_admin(brand_id, admin_id):
              

                         maintenances = maintenances.filter(user_id=user_id)
              

                +    
              

                +    if start_time and end_time:
              

                +        start_time = datetime.strptime(start_time, '%Y%m%d')
              

                +        end_time = datetime.strptime(end_time + ' 23:59:59', '%Y%m%d %H:%M:%S')
              

                +        maintenances = maintenances.filter(created_at__range=(start_time, end_time))
              

                +
              

                +    if query:
              

                +        maintenances = maintenances.filter(Q(phone=query) | Q(name__icontains=query) | Q(sn=query))
              

                +    
              

                +    if maintenance_status:
              

                +        maintenances = maintenances.filter(maintenance_status=maintenance_status)
              

                 
              

                     count = maintenances.count()
              

                     maintenances = [maintenance.data for maintenance in maintenances]